Rem  Copyright (c) 1999, 2002 by Marcelo F. Ochoa.  All Rights Reserved.
Rem
Rem   NAME
Rem     cache_spc.pls - DBPrism / Cocoon2 External Cache Invalidator utilities
Rem   PURPOSE
Rem     Provides a set of procedures to invalidate pages on Cocoon External
Rem     Invalidator Server.
Rem   NOTES
Rem
Rem   HISTORY
Rem     mochoa@ieee.org   2/17/02 -  Creation version 1.0.0
Rem

CREATE OR REPLACE PACKAGE cache AS

-- version 1.0.0
-- initial

type parameter_arr is table of varchar2(4096) index by binary_integer;

type cache_parameters is RECORD
   (
      names     parameter_arr,
      vals      parameter_arr,
      num_vals  binary_integer
   );

null_parameter cache_parameters;

procedure cms_invalidate_page(machine in varchar2, 
                              port in integer, 
                              page_url in varchar2);

procedure invalidate(machine in varchar2, 
                     port in integer, 
                     uriprefix in varchar2,
                     uriexp in varchar2,
                     sitemap in cache_parameters default null_parameter,
                     http in cache_parameters default null_parameter,
                     cookies in cache_parameters default null_parameter);
END cache;
/
